
module.exports = {
  DB_TABLES_SQL: ` select A.name TABLE_NAME, ISNULL(B.value, '') TABLE_COMMENT `
               + ` from sys.tables A left join sys.extended_properties B `
               + ` on B.major_id=A.object_id and B.minor_id=0 `,
  DB_TABLES_COLUMNS: (tableName) => ` select A.name COLUMN_NAME, B.name DATA_TYPE, A.length CHARACTER_MAXIMUM_LENGTH, C.value COLUMN_COMMENT `
  + ` from sys.syscolumns A `
  + ` left join systypes B on A.xtype=B.xtype `
  + ` left join sys.extended_properties C on A.id=C.major_id and A.colid=C.minor_id `
  + ` where A.id=object_id('${tableName}') `
}